2 Electricity
2.1 Utility Service Area Maps
To identify the utilities operating within our 11-county study area, we utilized data sets published by state sources. The outcome of our data collection, yielding a list of distinct utilities for which activity data should be collected, resides within distinct_electricity_util_WI.RDS (7 utilities, with four co-op utilities, three municipality utilities, and one investor-owned utility) and distinct_electricity_util_type_MN.RDS (18 utilities, with eight co-op utilities, nine municipality utilities, and one investor-owned utility)
2.1.1 Minnesota
The Minnesota Public Utilities Commission publishes and maintains a map of electric utility service areas (Office 2023). Though this dataset is statewide(see fig. X), it is clipped to only include utility service areas within the nine Minnesota counties included in the study area of this inventory (see fig. Y – note that utilities operating across county lines have a polygon covering the extent of their service territory within each and every county they operate within).
2.1.2 Wisconsin
The Public Services Commission of Wisconsin publishes and maintains maps of service territories for electric utilities operating within the state. This data set relies upon, and is accurate to, “the extent that various sources [utilities] supplied accurate data.” (Wisconsin Public Service Commission and Tomaszewski 2024) This dataset spans the whole state of Wisconsin (see fig, X), and both clipped to the two Wisconsin counties included in the study area of this inventory (see fig. Y). However, because Wisconsin utilities do not report energy deliveries to the county level, we also generate a file with the entire service area of utilities that operate within Pierce and St. Croix County (see fig. Z), so that we can calculate population served by these utilities both within and without of our study area, as an input to estimated/modeled number of customer accounts and total energy deliveries to Pierce and St. Croix County.
inscope
InScope whole territory
2.2 Utility Activity Data
2.2.1 Minnesota
Under Minnesota Administrative Rules Chapter 7610 (Minnesota Department of Commerce, n.d.), utilities are required to file an annual data report that supports the identification of “emerging energy trends based on supply and demand, conservation and public health and safety factors, and to determine the level of statewide and service area needs.” (Minnesota Department of Commerce 2022) This includes a report of county-level energy deliveries (reported in thousand cubic feet, commonly written as mcf). Because the information is structured in this manner, natural gas emissions at the county-level can be estimated as a direct function of energy deliveries to counties reported by utilities, which isn’t the case in Wisconsin (some modeling and estimation is required in WI).
For electric… great river
#bar graph with utility county data
#some data exists for MN customer counts… could be worthwile to calculate account level average for comparison to WI
2.2.2 Wisconsin
Under Wis. Stat. § 196.07, investor- and municipally owned electric utilities operating within the state of Wisconsin must submit annual reports to the State which include an array of information related to utility finance and operations, including key figures leveraged in our data collection, such as total energy deliveries made (in units of kWh) and total number of customer accounts within each county (Legislature, n.d.).
Of the seven in-scope electric utilities, only three (the investor- and municipally-owned utilities) were required to make these reports to the State in 2021 (four of the in-scope electric utilities are cooperative utilities); state data was leveraged in this case. For the four utilities (all cooperative utilities) not making these reports, we relied upon the detailed data files provided by the EIA, recording the responses of utilities to the Annual Electric Power Energy Report (Form EIA-861). Two utilities (Dunn Energy Cooperative and Polk-Burnett Electric Cooperative) filled the long version of the form, and two (St. Croix Electric Cooperative and Pierce-Pepin Electric Cooperative Services) filled the short form. For our purposes, both the long and short form provided suitable activity information (total energy delivered, total customers) to allocate energy deliveries to counties in concert with Census population data, in the process outlined below.
Because Wisconsin utilities do not report energy deliveries at the county level, it was necessary to estimate energy deliveries by a given utility i within a particular county j. For those three utilities who reported county-level customer counts and total customer counts to the state, we estimated mWh delivered by utility i in county j by multiplying their total statewide energy deliveries (as reported to the relevant state authorities) by the proportion of their customers residing in each of our two study area counties.
\[mWhDelivered_iCounty_j = (mWhEnergyDeliveries_i \times {ProportionOfTotalUtilityCustomers_j}) \]
To calculate the estimated energy delivered by utility i in county j for the four utilities that did not report county-level customer counts, we used population figures to allocate energy deliveries to counties. We took the actual total energy delivered by utility i (as reported to the relevant federal authorities) and multiplied this by the proportion of population within each utility’s entire service area residing within county j at the 2020 decennial Census.
\[mWhDelivered_iCounty_j = (mWhDelivered_i \times {ProportionOfTotalUtilityPopulation_j}) \]
The factor ProportionOfTotalUtilityPopulationj was calculated by first spatially joining the two…. (where each polygon represents a given utility’s service terrirory within a given county) to a spatial file containing total population for Census blocks using the block centroids, and then summing This step was completed in ArcGIS Pro and brought back to R due to memory constraints in RStudio on the relevant Met Council staffer’s work machine.
Inquiries have been made…
Because all four “in-scope” natural gas utilities in Wisconsin are investor-owned, we were able to estimate county-wide emissions from natural gas in 2021 by first calculating the proportion of each utility customer’s residing within Pierce and St. Croix counties, and allocating that proportion of the utility’s total reported energy delivery to each county. This approach represents a divergence from our Minnesota process, which involves aggregating county-level numbers directly reported by utilities, and implicitly assumes that customer accounts across counties within the operations of a given utility have the same average per-account demand for energy, when in actuality this is likely impacted by land-use mix and relative magnitude/scale of residential and commercial/industrial utility accounts within a given county (citation needed?)
#histogram or other visualization of customer
For electric… justifying modeling approach (reference to mean, use of a weighted average of per-account numbers for all utilities where we have actual and estimated per-account figures. All an estimation.
For electric.. more detail on how population in service territories was used to 1) estimate customer/account counts, 2) allocate total utility numbers based on estimated accounts within the in-scope area, and 3) use estimated per-customer energy deliveries, alongside population figures and total customer counts within and without our study area for the two utilities that didn’t energy activity to the state or federal government, to model energy delivery –> customers/cus
Data source description, type
- Quality rank (See Table C.2)
- How, when, and why was the data collected?
- If this is a modeled dataset, what is the sample?
- What is the raw unit of measurement?
- How was this data accessed? Include any relevant links/citations, code, or downloads.
- What data cleaning or wrangling was completed? How did you test these processes and outputs?
- What is the geographic and temporal scope? Did you complete any aggregation?
- What version is the data? Were there other versions available? If so, why did you choose this version?
- What assumptions are made when we use this dataset?
- Which subject matter expert (SME) reviewed this data?
- Describe testing used to verify data
Be sure to add a citation of this dataset to the Zotero shared library.
2.2.2.0.1 Data characteristics
- Were there any missing data? How did you handle missing data?
- Plots, tables, and description of data distribution
- Variance, Z-Score, quantiles
- Facet views by categorical variables
2.2.2.0.2 Limitations
- Usually only samples county and state roads, primary arterials
- Not every site is sampled every year
Additionally, aggregating
2.2.2.1 Vehicle distribution by weight
Introduction text Data source description, type
- Quality rank (See Table C.2)
- How, when, and why was the data collected?
- If this is a modeled dataset, what is the sample?
- What is the raw unit of measurement?
- How was this data accessed? Include any relevant links/citations, code, or downloads.
- What data cleaning or wrangling was completed? How did you test these processes and outputs?
- What is the geographic and temporal scope? Did you complete any aggregation?
- What version is the data? Were there other versions available? If so, why did you choose this version?
- What assumptions are made when we use this dataset?
- Which subject matter expert (SME) reviewed this data?
- Describe testing used to verify data
Be sure to add a citation of this dataset to the Zotero shared library.
2.2.2.1.1 Data characteristics
- Were there any missing data? How did you handle missing data?
- Plots, tables, and description of data distribution
- Variance, Z-Score, quantiles
- Facet views by categorical variables
